Quote:

---

SQL query:

CREATE TABLE `pos_info` (
`pos_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`corp` varchar( 255 ) NOT NULL ,
`pos_size` tinyint( 4 ) NOT NULL ,
`pos_race` tinyint( 4 ) NOT NULL ,
`isotope` int( 11 ) NOT NULL default '0',
`oxygen` int( 11 ) NOT NULL default '0',
`mechanical_parts` int( 11 ) NOT NULL default '0',
`coolant` int( 11 ) NOT NULL default '0',
`robotics` int( 11 ) NOT NULL default '0',
`uranium` int( 11 ) NOT NULL default '0',
`ozone` int( 11 ) NOT NULL default '0',
`heavy_water` int( 11 ) NOT NULL default '0',
`strontium` int( 11 ) NOT NULL default '0',
`system` varchar( 255 ) NOT NULL ,
`sovereignty` tinyint( 1 ) NOT NULL default '0',
`status` varchar( 255 ) NOT NULL default '0',
`owner_id` int( 11 ) default NULL ,
`pos_status` tinyint( 10 ) NOT NULL default '1',
PRIMARY KEY ( `pos_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 21

---

Quote:

---

Error

SQL query:

CREATE TABLE IF NOT EXISTS `npc_hanger` (
`corp` varchar( 255 ) NOT NULL ,
`system` varchar( 255 ) NOT NULL ,
`isotope` int( 10 ) unsigned NOT NULL ,
`oxygen` int( 10 ) unsigned NOT NULL ,
`mechanical_parts` int( 10 ) unsigned NOT NULL ,
`coolant` int( 10 ) unsigned NOT NULL ,
`robotics` int( 10 ) unsigned NOT NULL ,
`uranium` int( 10 ) unsigned NOT NULL ,
`ozone` int( 10 ) unsigned NOT NULL ,
`heavy_water` int( 10 ) unsigned NOT NULL ,
`strontium` int( 10 ) unsigned NOT NULL ,
`charters` int( 10 ) unsigned NOT NULL ,
PRIMARY KEY ( `corp` , `system` )
)

MySQL said: Documentation
#1071 - Specified key was too long. Max key length is 500

---

Originally by: franny

---

Originally by: Johnathan Roark

---

Server stats:
PHP5 (more info) 5.1.6 -
MySQL 4.0.27 -

the redirect errors are occuring on anything that uses either user-transaction.php and pos-transaction.php. Maybe something wrong with redirect.php?

---

you have the pos tracker files in a sub directory /postracker ?
the new(current) redirect file gave me errors when I had it in a base lvl directory
to clearify, I had my POStracker files in 'http://hostname/' it gave errors with the current redirect, I moved it to /postracker and it works fine

you could always try the old redirect file
the old redirect file looked like

Originally by: old redirect

---

<?php
function redirect($url) {
if (!headers_sent()) {
header('Location: http://hostname/postrackerpath/' . $url);
} else {
die('Could not redirect; Headers already sent.');
}
}
?>

---

---

Originally by: Utoxin

---

1.0 Progress Chart

Installer - Done
Corp Hangar Array Fuel Storage - Done
NPC Hangar Fuel Storage - Done
Online/Offline Status for Structures - Done
Refuel From Hangars - Planning

---

Originally by: Utoxin

---

Hmmm. I'll test some more, but my initial tests seemed fine in that regard.

---

Originally by: Space Hog

---

I was wondering if someone can help me here. I downloaded it, installed it. and when I register with it its not adding a line to the database. And when i login I get a blank page.

---

Originally by: Salia Deluri

---

^^np, it was a good learning experience for me:)

So OK a few things.
First the problem child.
How do I fix the system showing 0d 0h left if you are not using CPU even though you have a lot of heavy water?

---

Originally by: Salia Deluri

---

Second
I was looking at adding some fields. Group owner, fuel technician group and planet/moon.
The reason being is I want to create some views that are grouped by what group owns then and what group is responsible for fueling them.

---

Originally by: CaldFighter

---

any update on this?

mainly looking for the faction towers but silo support would be great too. (/me wishes he could program)

---

Originally by: Salia Deluri

---

So now the fun will begin.
Need to implement the new hold capacities on the towers.

---

Originally by: Gilgamoth

---

Originally by: MrRx7

---

We used the original structor as much as we could, however we have expanded beyond the start of 11 tables to over 22 to take in effect all the new stuff.

---

Please say that they all start with a prefix such as "pos_"? It took me quite a while to graft the current SF code so that it doesn't clash with my current tables and it makes patching and updates a biatch.

Regards,

Gil

---

Originally by: Salia Deluri

---

^^ Call me crazy but I have an aversion to putting all my moon data in someone else's DB. Please don't take offense to that just very paranoid as it is.

---